USE [movie]
GO

/****** Object:  StoredProcedure [dbo].[mov_getStates]    Script Date: 05/21/2011 13:17:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'mov_getStates' AND type = 'P') DROP PROCEDURE mov_getStates
GO






-- =============================================
-- Modified:    Pritam Bhat
-- Create date: 5/20/2011
-- Description:	This procedure returns list of all states

-- =============================================
CREATE PROCEDURE [dbo].[mov_getStates] 	

AS
BEGIN
	
	SET NOCOUNT ON;



SELECT state_ID, state_short, state_long
FROM state st

END





GO


